Evaluate(Object[]) Method

In This Topic

Searches for a value in the first column of a table array and returns a value in the same row from another column in the table array.

Syntax

'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As Object _
) As Object

'Usage
 
Dim instance As CalcVLookupFunction
Dim args() As Object
Dim value As Object
 
value = instance.Evaluate(args)

public override object Evaluate( 
   object[] args
)

args

The args contains 3 - 4 items: lookup_value, table_array, col_index_num, [range_lookup].

Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

Col_index_num The column number in table_array from which the matching value must be returned.

[Range_lookup] is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

A System.Object value that indicates the evaluate result.